/*** 
This set of do-files loads and processes public data used throughout the paper
to construct figures, tables and estimates. 
***/

*-------------------------------------------------------------------------------
* Configuration
*-------------------------------------------------------------------------------

project figstabs, cd

project, uses(code/config_project.do) raw
include code/config_project.do 

*-------------------------------------------------------------------------------
* Build
*-------------------------------------------------------------------------------

* American Community Survey (ACS)
project, do("code/ACS 2014-2018 5-Year County/Combining Code.do")
project, do("code/ACS 2014-2018 5-Year ZCTA/Combining Code.do")
project, do("code/ACS 2014-2018 5-Year State/Combining Code.do")

* Advanced Monthly Retail Trade Survey (MARTS)
project, do("code/figs/Spending/Spending - Load MARTS Data.do")

* National Income and Product Accounts (NIPA)
project, do("code/figs/Spending/Spending - Load NIPA Data.do")

* LEHD Origin-Destination Employment Statistics (LODES)
project, do("code/figs/Employment/Employment - Load LODES Data.do")

* Quarterly Census of Employment and Wages (QCEW)
project, do("code/figs/Employment/Employment - Load QCEW Data.do")

* Current Employment Statistics (CES)
project, do("code/figs/Employment/Employment - Load CES Data.do")

* Current Population Survey (CPS)
project, do("code/figs/Employment/Employment - Create CPS national series.do")
project, do("code/figs/Employment/Employment - Create CPS by wage quartile series.do")
project, do("code/figs/Employment/Employment - Create CPS by wage quartile series excluding CA NY MA.do")
project, do("code/figs/Employment/Employment - Create CPS by wage quartile and citizenship status series.do")
